<?php
/**
* @file $Id: GetTeacher.fnc.php 161 2006-09-07 06:21:17Z doritojones $
* @package Focus/SIS
* @copyright Copyright (C) 2006 Andrew Schmadeke. All rights reserved.
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.txt
* Focus/SIS is free software. This version may have been modified pursuant
* to the GNU General Public License, and as distributed it includes or
* is derivative of works licensed under the GNU General Public License or
* other free or open source software licenses.
* See COPYRIGHT.txt for copyright notices and details.
*/

function GetTeacher($teacher_id,$title='',$column='FULL_NAME',$schools=true)
{	global $_FOCUS;
	
	if(!$_FOCUS['GetTeacher'])
	{
		$QI=DBQuery("SELECT STAFF_ID,LAST_NAME||', '||FIRST_NAME AS FULL_NAME,USERNAME,PROFILE FROM USERS WHERE SYEAR='".UserSyear()."'".($schools?" AND SCHOOLS LIKE '%,".UserSchool().",%'":''));
		$_FOCUS['GetTeacher'] = DBGet($QI,array(),array('STAFF_ID'));
	}
	
	return $_FOCUS['GetTeacher'][$teacher_id][1][$column];
}
?>